Error running dbsanity on MS SQL Server 2005

Everything about DB Sanity

Error running dbsanity on MS SQL Server 2005

Postby arazauci » Sat Feb 26, 2011 9:46 am

C:\myprojects\dbsanity>dbsanity.bat wsp_metadata_baseline
Local classpath: .;C:\dbsanity\bin;C:\dbsanity\lib\*
00:40:10,004 INFO (main) [JDBCDBImporter] Imported core database metadata withi
n 735 ms.
Exception in thread "main" java.lang.NullPointerException
at org.databene.jdbacl.model.jdbc.JDBCDBImporter.importSchemas(JDBCDBImp
orter.java:243)
at org.databene.jdbacl.model.jdbc.JDBCDBImporter.importDatabase(JDBCDBIm
porter.java:185)
at org.databene.dbsanity.DbSanity.getMetaData(DbSanity.java:297)
at org.databene.dbsanity.DbSanity.execute(DbSanity.java:234)
at org.databene.dbsanity.DbSanity.main(DbSanity.java:371)

C:\myprojects\dbsanity>

test.xml file

<?xml version="1.0"?>
<dbsanity>
<check name="testing">
<sql>
SELECT *
FROM build_info
where publish_build is null
</sql>
</check>
</dbsanity>

not sure what am I doing wrong
arazauci
 
Posts: 1
Joined: Sat Feb 26, 2011 9:43 am

Re: Error running dbsanity on MS SQL Server 2005

Postby Volker Bergmann » Mon Feb 28, 2011 7:52 am

Hi arazauci,

are you sure that you have set up the environment file properly? This exception occurs if you configure a catalog which is not found. If you are not sure about the correct JDBC settings, edit the log4j.xml file, add a category

Code: Select all
    <category name="org.databene.jdbacl.model.jdbc">
       <priority value="debug"/>
    </category>


and run DB Sanity again. Its output will show you which catalogs (message 'found catalog #') and schemas (messages 'importing schema #' or 'ignoring schema #') are available. Find the appropriate catalog and schema and configure them in the 'env' file.

If that does not help, it may be a side effect of some bugs induced in recent metamodel changes of the underlying jdbacl library. I will create a bug fix release of DB Sanity in the next days.

Regards,
Volker 'databene' Bergmann

Need faster response times? phone support? onsite support? training? custom extensions? immediate bug fixes? Support Benerator evolution by buying services from Volker Bergmann!
User avatar
Volker Bergmann
 
Posts: 654
Joined: Sat Nov 10, 2007 2:40 pm


Return to DB Sanity

Who is online

Users browsing this forum: No registered users and 2 guests

cron