Error : "Could not get database metadata"

[PrashantBahuguna]

When the application is run on the server this exception is raised in the console. The webpage gets live but when new user is signed up the application crashes with the error : "Could not open connection".

[ikismail]

@PrashantB248 Please verify your Database credentials, You have configured wrong username or password of your h2Database to the application.

[PrashantBahuguna]

I have checked, its "prashant" everywhere.

[ikismail]

@PrashantB248 the problem is your H2 settings. Change your H2 Database Settings to Generic H2 (Server). so that the JDBC URL will change according to your properties.

[PrashantBahuguna]

The same issue is there..

[ikismail]

Your configuration is wrong verify it clearly.

[PrashantBahuguna]

Unable to find the problem..!

[ikismail]

Send the snapshot of current application-config.xml and h2 settings

[PrashantBahuguna]

Is there any issue in the DB url ?

[ikismail]

your application-context.xml database configuration should be like this.

<!-- database properties DataSouorce -->
   <bean id="dataSource"
       class="org.springframework.jdbc.datasource.DriverManagerDataSource">
     <property name="driverClassName" value="org.h2.Driver" />
     <property name="url" value="jdbc:h2:tcp://localhost/~/test" />
     <property name="username" value="prashant" />
     <property name="password" value="prashant" />
   </bean>

your h2 database settings should be like this.

now stop the server clean the server directory and start it.

[PrashantBahuguna]

Made the changes. This issue has arised.

[ikismail]

reinstall your server

Fix Eclipse Tomcat not starting in 45 seconds

[PrashantBahuguna]

Solved..!! Live and running. Thank You so much for your help.!

[ChillBoss]

Bro..where is the database file?? like,i want the tables

[ikismail]

@ChillBoss I hope this will work How to open and export data from h2 bb.