Seam Gen Problem

[kasim]

This is probably something obvious but i cant figure it out.

When i run the ./seam generate-entities

i get No driver found error. i was assuming it was going off the one we defined in the setup. which i verified is there

Total time: 1 second
apple-nusairat:/usr/local/java/packages/jboss-seam-1.1.1.GA online$ ./seam generate-entities
Buildfile: build.xml

validate-workspace:

validate-project:

generate-entities:
[hibernate] Executing Hibernate Tool with a JDBC Configuration (for reverse engineering)
[hibernate] 1. task: hbm2java (Generates a set of .java files)
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.Environment <clinit>
[hibernate] INFO: Hibernate 3.2 cr4
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.Environment <clinit>
[hibernate] INFO: hibernate.properties not found
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.Environment buildBytecodeProvider
[hibernate] INFO: Bytecode provider name : cglib
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.Environment <clinit>
[hibernate] INFO: using JDK 1.4 java.sql.Timestamp handling
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.connection.DriverManagerConnectionProvider configure
[hibernate] INFO: Using Hibernate built-in connection pool (not for production use!)
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.connection.DriverManagerConnectionProvider configure
[hibernate] INFO: Hibernate connection pool size: 20
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.connection.DriverManagerConnectionProvider configure
[hibernate] INFO: autocommit mode: false
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.connection.DriverManagerConnectionProvider configure
[hibernate] INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.connection.DriverManagerConnectionProvider configure
[hibernate] INFO: connection properties: {user=root, password=****}
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] WARNING: Could not obtain connection metadata
[hibernate] java.sql.SQLException: No suitable driver
[hibernate] at java.sql.DriverManager.getConnection(DriverManager.java:545)
[hibernate] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[hibernate] at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
[hibernate] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
[hibernate] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1929)
[hibernate] at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:38)
[hibernate] at org.hibernate.tool.ant.JDBCConfigurationTask.doConfiguration(JDBCConfigurationTask.java:82)
[hibernate] at org.hibernate.tool.ant.ConfigurationTask.getConfiguration(ConfigurationTask.java:55)
[hibernate] at org.hibernate.tool.ant.HibernateToolTask.getConfiguration(HibernateToolTask.java:298)
[hibernate] at org.hibernate.tool.ant.HibernateToolTask.getProperties(HibernateToolTask.java:314)
[hibernate] at org.hibernate.tool.ant.ExporterTask.configureExporter(ExporterTask.java:94)
[hibernate] at org.hibernate.tool.ant.Hbm2JavaExporterTask.configureExporter(Hbm2JavaExporterTask.java:34)
[hibernate] at org.hibernate.tool.ant.ExporterTask.execute(ExporterTask.java:39)
[hibernate] at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:182)
[hibernate] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[hibernate] at org.apache.tools.ant.Task.perform(Task.java:364)
[hibernate] at org.apache.tools.ant.Target.execute(Target.java:341)
[hibernate] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[hibernate] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[hibernate] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[hibernate] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[hibernate] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[hibernate] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[hibernate] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[hibernate] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[hibernate] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.dialect.Dialect <init>
[hibernate] INFO: Using dialect: org.hibernate.dialect.MySQLDialect
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
[hibernate] INFO: Using default transaction strategy (direct JDBC transactions)
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
[hibernate] INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Automatic flush during beforeCompletion(): disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Automatic session close at end of transaction: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Scrollable result sets: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: JDBC3 getGeneratedKeys(): disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Connection release mode: auto
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Default catalog: garageSaleDb
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Maximum outer join fetch depth: 2
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Default batch fetch size: 1
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Generate SQL with comments: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Order SQL updates by primary key: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
[hibernate] INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
[hibernate] INFO: Using ASTQueryTranslatorFactory
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Query language substitutions: {}
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: JPA-QL strict compliance: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Second-level cache: enabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Query cache: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory createCacheProvider
[hibernate] INFO: Cache provider: org.hibernate.cache.NoCacheProvider
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Optimize cache for minimal puts: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Structured second-level cache entries: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Statistics: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Deleted entity synthetic identifier rollback: disabled
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.cfg.SettingsFactory buildSettings
[hibernate] INFO: Default entity-mode: pojo
[hibernate] Jan 22, 2007 11:56:51 PM org.hibernate.connection.DriverManagerConnectionProvider close
[hibernate] INFO: cleaning up connection pool: jdbc:mysql://localhost
[hibernate] An exception occurred while running exporter #2:hbm2java (Generates a set of .java files)
[hibernate] To get the full stack trace run ant with -verbose
[hibernate] org.hibernate.exception.JDBCConnectionException: Getting database metadata
[hibernate] java.sql.SQLException: No suitable driver

BUILD FAILED
/usr/local/java/packages/jboss-seam-1.1.1.GA/seam-gen/build.xml:793: org.hibernate.exception.JDBCConnectionException: Getting database metadata

[dustismo]

Did you find a solution? I am getting the exact same message..

-Dustin

[saeediqbal1]

did you confirm if the *connector*.jar file was not missing?

[saeediqbal1]

Some pointers of the same problem

http://forum.java.sun.com/thread.jspa?threadID=691687&messageID=4020886


http://www.opensubscriber.com/message/[e-mail]/1407968.html//www.opensubscriber.com/message/[e-mail]/1407968.html

http://forum.hibernate.org/viewtopic.php?t=945739


let me know what if any of that fixes the problem please

[dustismo]

Yes the mysql driver jar is exactly where I said it was during seam setup. And I am using a connection url of the form jdbc:mysql://address:port/databasename..

Is there somewhere else I need to add the mysql jar?

thanks for the help,
Dustin

[saeediqbal1]

Yes i think hibernate is looking for it somewhere else. in that other site they said shared/lib folder, but i dont know where in seam. I would try putting that connector in a few other folders and restart the AS and try again.

Gavin could help point out exactly what to do.

[saeediqbal1]

off the top of my mind 3 places i can think of putting that connector.jar in

1) jboss as/server/default/lib

2) seam/lib/

3) seam/seam-gen/lib/

bounce the server and try. let us know

[maxandersen]

either your jdbc url is wrong or the driver location you entered during seam setup is not correct.

[gsegura]

To find out where is looking for the jar driver try using filemon by sysinternals (I hope I'm not offending any rule by talking about third party product, it's free though)

[nvisser]

It looks to me like "seam setup" added some extra backslashes to the seam-gen/build.properties.

Make sure you have a line in there that looks like this -- without extra backslashes.


hibernate.connection.url=jdbc\:mysql\://localhost:3306/photo1

[gbc1]

I have my connector lib in Seam\Seam-gen\lib dir. At setup I jast typed .\lib\connector.jar and it worked.

Greetz GHad