phpbb2jforum migration

[Migrated From Jforum.net]

Hello! Thanks for the good forum!
I've just tried your migration tool and found out that it doesn't work with postgresql.
Changing fields from SystemGlobals.properties to:

database.driver = org.postgresql.Driver
database.jforum.url = jdbc:postgresql://127.0.0.1/forum_linuxshop_ru
database.queries = mysql_queries.sql
dbname = forum_linuxshop_ru
dbhost = localhost
dbuser = loluser
dbpasswd = root

has no effect.

java -cp bin:/usr/java/j2sdk1.4.2_04/jre/lib/ext/pg74.213.jdbc3.jar net.jforum.tools.phpbb2jforum.Main forum_linuxshop_ru loluser loluser localhost
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at net.jforum.tools.phpbb2jforum.Main.openConnection(Main.java:42)
at net.jforum.tools.phpbb2jforum.Main.main(Main.java:273)

do you plan to fix it? i've looked for migration tool's sources but have found nothing..
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

The " No suitable driver " tells that you don't have the postgresql jar in the classpath.

I never tested the migration tool with postgresql.. I'm not sure if it will work.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Rafael,

I've tried to use the postgresql jdbc driver but I get the same error message.

Debugging the code, I found that the program tries to connect using the string: jdbc:mysql://localhost instead of the property string that I put in SystemGlobals.properties file.

Take a look at the screenshot anexed.

Maybe it's hardcoded inside the class, can you take a look at this code for me?

I'm working on a migration using postgresql, maybe you could share the source code for us to make the necessary modifications.

Thanks

Henrique
[originally posted on jforum.net by hemoliveira]

[Migrated From Jforum.net]

In fact, the connection URL format is hardcoded. For now, you can get the source at

https://jforum-tools.dev.java.net/source/browse/jforum-tools/phpbb2jforum/src/net/jforum/tools/phpbb2jforum/Main.java?rev=1.8&view=markup

and change the connection URL in the main() method.

Rafael
[originally posted on jforum.net by Rafael Steil]